-- EVENT Table changes
ALTER TABLE [Event] DROP COLUMN Category_Code
GO
ALTER TABLE [Event] ADD Event_Region NVarChar(200)
GO
ALTER TABLE [Event] ADD Event_Country NVarChar(200)
GO
ALTER TABLE [Event] ADD Event_State NVarChar(200)
GO
ALTER TABLE [Event] ADD Event_City NVarChar(200)
GO
ALTER TABLE [Event] ADD  CONSTRAINT [DF_Event_Date_Created]  DEFAULT (getdate()) FOR [Date_Created]
GO
ALTER TABLE [Event] ADD  CONSTRAINT [DF_Event_Date_Modified]  DEFAULT (getdate()) FOR [Date_Modified]
GO

UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Brandon''s House' WHERE Event_Code =1
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Kremmling', Event_Location='' WHERE Event_Code =3
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Marilyn''s House' WHERE Event_Code =4
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='Ryan''s Cabin' WHERE Event_Code =6
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Montana', Event_City='Glacier National Park', Event_Location='' WHERE Event_Code =7
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Washington Park' WHERE Event_Code =8
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Dillon', Event_Location='' WHERE Event_Code =9
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Golden', Event_Location='Noth Table Mountain' WHERE Event_Code =10
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Wyoming', Event_City='Grand Teton National Park', Event_Location='' WHERE Event_Code =11
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Alberta', Event_City='Waterton National Park', Event_Location='' WHERE Event_Code =12
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Wyoming', Event_City='Jackson', Event_Location='' WHERE Event_Code =13
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Wyoming', Event_City='Yellowstone National Park', Event_Location='' WHERE Event_Code =14
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Ouray', Event_Location='' WHERE Event_Code =15
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='Ryan Compound' WHERE Event_Code =16
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Boulder', Event_Location='' WHERE Event_Code =17
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Boulder', Event_Location='' WHERE Event_Code =18
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Littleton', Event_Location='' WHERE Event_Code =19
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Mel''s Apartment' WHERE Event_Code =20
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Ontario', Event_City='Toronto', Event_Location='' WHERE Event_Code =21
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Cherry Creek' WHERE Event_Code =22
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='University of Colorado Denver' WHERE Event_Code =23
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Idaho Springs', Event_Location='Mt. Evans' WHERE Event_Code =24
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Ouzel Falls' WHERE Event_Code =25
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Fern Lake' WHERE Event_Code =26
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='LuLu City' WHERE Event_Code =27
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Haynach Lake' WHERE Event_Code =28
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Manitu Springs', Event_Location='Garden of the Gods' WHERE Event_Code =29
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Telluride', Event_Location='' WHERE Event_Code =30
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Gunnison', Event_Location='Grand Canyon of the Gunnison' WHERE Event_Code =31
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Idaho Springs', Event_Location='Mt. Evans' WHERE Event_Code =32
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Boulder', Event_Location='Flatirons' WHERE Event_Code =33
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Fern Lake' WHERE Event_Code =34
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Our Apartment' WHERE Event_Code =35
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Flattop Mountain' WHERE Event_Code =36
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='' WHERE Event_Code =37
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Golden', Event_Location='Clear Creek Canyon' WHERE Event_Code =38
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='xxx', Event_Location='Boreas Pass' WHERE Event_Code =39
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Bull and Bush' WHERE Event_Code =40
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =41
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Eldorado Canyon State Park', Event_Location='' WHERE Event_Code =42
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Our Apartment' WHERE Event_Code =43
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='' WHERE Event_Code =44
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Golden', Event_Location='Table Mountain' WHERE Event_Code =45
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='Down Town Denver' WHERE Event_Code =46
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Rocky Mountain National Park', Event_Location='Bear Lake' WHERE Event_Code =47
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Wade', Event_Location='Roosevelt National Froest' WHERE Event_Code =48
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Utah', Event_City='Arches National Park', Event_Location='Middle Vrain Trail' WHERE Event_Code =49
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Utah', Event_City='Canyonlands National Park', Event_Location='' WHERE Event_Code =50
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Utah', Event_City='Capitol Reef National Park', Event_Location='' WHERE Event_Code =51
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Utah', Event_City='Bryce Canyon National Park', Event_Location='' WHERE Event_Code =52
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Utah', Event_City='Zion National Park', Event_Location='' WHERE Event_Code =53
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Arizona', Event_City='Grand Canyon National Park', Event_Location='' WHERE Event_Code =54
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Arizona', Event_City='Petrified Forest National Park', Event_Location='' WHERE Event_Code =55
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Durango', Event_Location='Durango Railroad' WHERE Event_Code =56
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Mesa Verde National Park', Event_Location='' WHERE Event_Code =57
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Four Corners', Event_Location='' WHERE Event_Code =58
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Great Sand Dunes National Park', Event_Location='' WHERE Event_Code =59
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Aspen', Event_Location='Conundrum Hot Springs' WHERE Event_Code =60
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Glenwood Springs', Event_Location='' WHERE Event_Code =61
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Golden', Event_Location='' WHERE Event_Code =62
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =63
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Colorado Springs', Event_Location='Broadmore Hotel' WHERE Event_Code =64
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =65
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='South Dakota', Event_City='Mt. Rushmore National Monument', Event_Location='' WHERE Event_Code =66
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='South Dakota', Event_City='Wind Cave and Jewel Cave National Park', Event_Location='' WHERE Event_Code =67
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='South Dakota', Event_City='Badlands National Park', Event_Location='' WHERE Event_Code =68
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Deleware Water Gap', Event_Location='' WHERE Event_Code =69
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =70
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Deleware Water Gap', Event_Location='' WHERE Event_Code =71
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =72
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =73
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =74
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =75
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =76
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Ashville', Event_Location='' WHERE Event_Code =77
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =78
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =79
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Portland', Event_Location='' WHERE Event_Code =80
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =81
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =82
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =83
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =84
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Poland Spring', Event_Location='' WHERE Event_Code =85
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =86
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =87
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =88
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =89
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =90
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =91
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =92
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =93
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Pennsylvania', Event_City='Hersey', Event_Location='' WHERE Event_Code =94
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =95
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =96
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =97
UPDATE Event SET Event_Region='Europe', Event_Country='Italy', Event_State='Northern Italy', Event_City='Milan', Event_Location='' WHERE Event_Code =98
UPDATE Event SET Event_Region='Europe', Event_Country='Italy', Event_State='Northern Italy', Event_City='Venice', Event_Location='' WHERE Event_Code =99
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Rhone Alpes', Event_City='Chamonix', Event_Location='' WHERE Event_Code =100
UPDATE Event SET Event_Region='Europe', Event_Country='Italy', Event_State='Northern Italy', Event_City='Cortina', Event_Location='' WHERE Event_Code =101
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =102
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =103
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =104
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =105
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =106
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =107
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =108
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =109
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =110
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Pennsylvania', Event_City='Lancaster', Event_Location='' WHERE Event_Code =111
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =137
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Pennsylvania', Event_City='Philadelphia', Event_Location='' WHERE Event_Code =138
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =139
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =140
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maryland', Event_City='Washington, DC', Event_Location='' WHERE Event_Code =141
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =142
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Catskills', Event_Location='' WHERE Event_Code =143
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Catskills', Event_Location='' WHERE Event_Code =144
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Adriondaks', Event_Location='' WHERE Event_Code =145
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Sandy Hook', Event_Location='' WHERE Event_Code =146
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =147
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Catskills', Event_Location='' WHERE Event_Code =148
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Hawaii', Event_City='Honolulu', Event_Location='' WHERE Event_Code =149
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Hawaii', Event_City='Kauai', Event_Location='' WHERE Event_Code =150
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Hampshire', Event_City='Gorham', Event_Location='' WHERE Event_Code =151
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Summerville', Event_Location='' WHERE Event_Code =152
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =153
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =154
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='Rockafeller Center' WHERE Event_Code =178
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =179
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =180
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =181
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Vernon', Event_Location='Mountain Creek Resort' WHERE Event_Code =182
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='Rutgers University' WHERE Event_Code =183
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =192
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =193
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =194
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =195
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =196
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =197
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =198
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =199
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =200
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Istanbul Province', Event_City='Istanbul', Event_Location='' WHERE Event_Code =201
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Olu Denize', Event_Location='' WHERE Event_Code =202
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Mediterranean Coast', Event_Location='' WHERE Event_Code =203
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Butterfly Valley', Event_Location='' WHERE Event_Code =204
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Olu Denize', Event_Location='' WHERE Event_Code =205
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Pinara', Event_Location='' WHERE Event_Code =206
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Kas', Event_Location='' WHERE Event_Code =207
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Kas', Event_Location='' WHERE Event_Code =208
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Myra', Event_Location='' WHERE Event_Code =209
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Mediterranean Coast', Event_Location='Lycian Way ' WHERE Event_Code =210
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Olympos', Event_Location='' WHERE Event_Code =211
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Mediterranean Coast', Event_City='Phaselis', Event_Location='' WHERE Event_Code =212
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Cappadocia Area', Event_City='Nevsehir', Event_Location='' WHERE Event_Code =213
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Cappadocia Area', Event_City='Nevsehir', Event_Location='' WHERE Event_Code =214
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Cappadocia Area', Event_City='Nevsehir', Event_Location='' WHERE Event_Code =215
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Cappadocia Area', Event_City='Nevsehir', Event_Location='' WHERE Event_Code =216
UPDATE Event SET Event_Region='Asia', Event_Country='Turkey', Event_State='Cappadocia Area', Event_City='Nevsehir', Event_Location='' WHERE Event_Code =217
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =218
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Pyrennes', Event_City='Pyrennes', Event_Location='' WHERE Event_Code =219
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Pyrennes', Event_City='Pyrennes', Event_Location='' WHERE Event_Code =220
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Pyrennes', Event_City='Pyrennes', Event_Location='' WHERE Event_Code =221
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Pyrennes', Event_City='Pyrennes', Event_Location='' WHERE Event_Code =222
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Pyrennes', Event_City='Pyrennes', Event_Location='' WHERE Event_Code =223
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Languedoc-Roussillon', Event_City='Collioure', Event_Location='' WHERE Event_Code =224
UPDATE Event SET Event_Region='Europe', Event_Country='Spain', Event_State='Communidad Valenciana', Event_City='Montserrate', Event_Location='' WHERE Event_Code =225
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =226
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =227
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =228
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =229
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =230
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =231
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =232
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =233
UPDATE Event SET Event_Region='Europe', Event_Country='France', Event_State='Ile-de France', Event_City='Paris', Event_Location='' WHERE Event_Code =234
UPDATE Event SET Event_Region='Europe', Event_Country='England', Event_State='Oxfordshire', Event_City='Buford', Event_Location='' WHERE Event_Code =235
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =236
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =237
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Harriman State Park', Event_Location='' WHERE Event_Code =238
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Arcadia National Park', Event_Location='' WHERE Event_Code =239
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Arcadia National Park', Event_Location='' WHERE Event_Code =240
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Arcadia National Park', Event_Location='' WHERE Event_Code =241
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Maine', Event_City='Arcadia National Park', Event_Location='' WHERE Event_Code =242
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =243
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Adriondaks', Event_Location='' WHERE Event_Code =244
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='xxx', Event_Location='' WHERE Event_Code =245
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =246
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Atlanta', Event_Location='' WHERE Event_Code =247
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Tannersville', Event_Location='' WHERE Event_Code =248
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Hampshire', Event_City='Gorham', Event_Location='' WHERE Event_Code =249
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Bear Mountain State Park', Event_Location='' WHERE Event_Code =250
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =251
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =252
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =253
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Fairmont', Event_Location='' WHERE Event_Code =254
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Illinois', Event_City='Chicago', Event_Location='' WHERE Event_Code =255
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =256
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =257
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =258
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Atlanta', Event_Location='' WHERE Event_Code =259
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Massachusetts', Event_City='Richmond', Event_Location='' WHERE Event_Code =260
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =261
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =262
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =263
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =264
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Bronx', Event_Location='' WHERE Event_Code =265
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =266
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =267
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =268
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =269
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =270
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =271
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =272
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='California', Event_City='Yosemite National Park', Event_Location='' WHERE Event_Code =273
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =274
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =275
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =276
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =277
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =278
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =279
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =280
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =281
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =282
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =283
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =284
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =285
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =286
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =287
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =288
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =289
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =290
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =291
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =292
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =293
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =294
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =295
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Wheeling', Event_Location='' WHERE Event_Code =296
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Pennsylvania', Event_City='Wilkes-barre', Event_Location='' WHERE Event_Code =297
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =298
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =299
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =300
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =301
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =302
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =303
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Buffalo', Event_Location='' WHERE Event_Code =304
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =305
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =306
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =307
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Everglades', Event_Location='' WHERE Event_Code =308
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =309
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =310
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =311
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =312
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =313
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Denver', Event_Location='' WHERE Event_Code =314
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =315
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Colorado', Event_City='Dillon', Event_Location='' WHERE Event_Code =316
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Saint Leo''s', Event_Location='' WHERE Event_Code =317
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Tampa', Event_Location='' WHERE Event_Code =318
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =319
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='Hillsborough', Event_Location='' WHERE Event_Code =320
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Gauteng', Event_City='Johannesburg', Event_Location='' WHERE Event_Code =322
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Limpopo', Event_City='Graskop', Event_Location='' WHERE Event_Code =323
UPDATE Event SET Event_Region='Africa', Event_Country='Swaziland', Event_State='Phuzumoya', Event_City='Mkhaya Game Reserve', Event_Location='' WHERE Event_Code =324
UPDATE Event SET Event_Region='Africa', Event_Country='Lesotho', Event_State='Masokoaneny', Event_City='Sani Pass', Event_Location='' WHERE Event_Code =325
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='KwaZulu Natal', Event_City='Drakensburg Mountains', Event_Location='' WHERE Event_Code =326
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Western Cape', Event_City='Cape Town', Event_Location='' WHERE Event_Code =327
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='KwaZulu Natal', Event_City='Giants Castle', Event_Location='' WHERE Event_Code =328
UPDATE Event SET Event_Region='Africa', Event_Country='Mozambique', Event_State='Inhambane Province', Event_City='Tofo', Event_Location='' WHERE Event_Code =329
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =330
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =331
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =332
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =333
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =334
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =335
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =336
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =337
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =338
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =339
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =340
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =341
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =342
UPDATE Event SET Event_Region='Africa', Event_Country='South Africa', Event_State='Mpumalanga', Event_City='Nelspruit', Event_Location='' WHERE Event_Code =343
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Pokhara', Event_Location='' WHERE Event_Code =352
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Tolka', Event_Location='' WHERE Event_Code =353
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Chhomrong', Event_Location='' WHERE Event_Code =354
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Chhomrong', Event_Location='' WHERE Event_Code =355
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Annapurna Base Camp', Event_Location='' WHERE Event_Code =356
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Sinuwa', Event_Location='' WHERE Event_Code =357
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Naya Pul', Event_Location='' WHERE Event_Code =358
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Pokhara', Event_Location='' WHERE Event_Code =359
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Pokhara', Event_Location='' WHERE Event_Code =360
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Pokhara', Event_Location='' WHERE Event_Code =362
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Annapurna Region', Event_City='Pokhara', Event_Location='' WHERE Event_Code =363
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Chitwan District', Event_City='Chitwan National Park', Event_Location='' WHERE Event_Code =364
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Chitwan District', Event_City='Chitwan National Park', Event_Location='' WHERE Event_Code =365
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Chitwan District', Event_City='Chitwan National Park', Event_Location='' WHERE Event_Code =366
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Chitwan District', Event_City='Chitwan National Park', Event_Location='' WHERE Event_Code =367
UPDATE Event SET Event_Region='Asia', Event_Country='India', Event_State='Haryana', Event_City='New Delhi', Event_Location='' WHERE Event_Code =368
UPDATE Event SET Event_Region='Asia', Event_Country='India', Event_State='Haryana', Event_City='New Delhi', Event_Location='' WHERE Event_Code =369
UPDATE Event SET Event_Region='Asia', Event_Country='India', Event_State='Haryana', Event_City='New Delhi', Event_Location='' WHERE Event_Code =371
UPDATE Event SET Event_Region='Asia', Event_Country='India', Event_State='Haryana', Event_City='Agra', Event_Location='' WHERE Event_Code =372
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Kathmandu', Event_Location='' WHERE Event_Code =373
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Patan', Event_Location='' WHERE Event_Code =374
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Kathmandu', Event_Location='' WHERE Event_Code =375
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Kathmandu', Event_Location='' WHERE Event_Code =376
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Bhaktapur', Event_Location='' WHERE Event_Code =377
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Bodhnath', Event_Location='' WHERE Event_Code =378
UPDATE Event SET Event_Region='Asia', Event_Country='Nepal', Event_State='Bagmati', Event_City='Pashupatinath', Event_Location='' WHERE Event_Code =379
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =380
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Holiday Valley', Event_Location='' WHERE Event_Code =381
UPDATE Event SET Event_Region='Europe', Event_Country='Finland', Event_State='Uusimaa', Event_City='Helsinki', Event_Location='' WHERE Event_Code =382
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =383
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Fairmont', Event_Location='' WHERE Event_Code =384
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =385
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Miami', Event_Location='' WHERE Event_Code =386
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =387
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Vermont', Event_City='Killington', Event_Location='' WHERE Event_Code =388
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Holiday Valley', Event_Location='' WHERE Event_Code =389
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =390
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='New York City', Event_Location='' WHERE Event_Code =391
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New Jersey', Event_City='New Brunswick', Event_Location='' WHERE Event_Code =392
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Puerto Natales', Event_Location='' WHERE Event_Code =393
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Torres Del Paine National Park', Event_Location='' WHERE Event_Code =394
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Torres Del Paine National Park', Event_Location='' WHERE Event_Code =395
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Torres Del Paine National Park', Event_Location='' WHERE Event_Code =396
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Torres Del Paine National Park', Event_Location='' WHERE Event_Code =397
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Torres Del Paine National Park', Event_Location='' WHERE Event_Code =398
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='El Calafate, Argentina', Event_Location='' WHERE Event_Code =400
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='Los Glacier National Park', Event_Location='' WHERE Event_Code =402
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='Los Glacier National Park', Event_Location='' WHERE Event_Code =403
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='Los Glacier National Park', Event_Location='' WHERE Event_Code =404
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='Los Glacier National Park', Event_Location='' WHERE Event_Code =405
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='El Calafate, Argentina', Event_Location='' WHERE Event_Code =406
UPDATE Event SET Event_Region='South America', Event_Country='Argentina', Event_State='Santa Cruz', Event_City='Los Glacier National Park', Event_Location='' WHERE Event_Code =407
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Bernardo O''Higgins National Park', Event_Location='' WHERE Event_Code =410
UPDATE Event SET Event_Region='South America', Event_Country='Chile', Event_State='Patagonia', Event_City='Magdalena Island', Event_Location='' WHERE Event_Code =420
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Massachusetts', Event_City='Boston', Event_Location='' WHERE Event_Code =425
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Massachusetts', Event_City='Boston', Event_Location='' WHERE Event_Code =430
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Massachusetts', Event_City='Boston', Event_Location='' WHERE Event_Code =435
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Massachusetts', Event_City='Boston', Event_Location='' WHERE Event_Code =440
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cleveland', Event_Location='' WHERE Event_Code =445
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =450
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =451
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =452
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Pennsylvania', Event_City='Allegheny State Park', Event_Location='' WHERE Event_Code =453
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =454
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Asheville', Event_Location='' WHERE Event_Code =455
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =456
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Florida', Event_City='Sarasota', Event_Location='' WHERE Event_Code =457
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Atlanta', Event_Location='' WHERE Event_Code =458
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =459
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =460
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =461
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =462
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Brasstown Valley', Event_Location='' WHERE Event_Code =463
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =464
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =465
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =466
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =467
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =468
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =469
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =470
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =471
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Georgia', Event_City='Blairsville', Event_Location='' WHERE Event_Code =472
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cleveland', Event_Location='' WHERE Event_Code =473
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cleveland', Event_Location='' WHERE Event_Code =474
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Michigan', Event_City='Sleeping Bear Dunes National Park', Event_Location='' WHERE Event_Code =475
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Michigan', Event_City='Hell', Event_Location='' WHERE Event_Code =476
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =477
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Ontario', Event_City='Toronto', Event_Location='' WHERE Event_Code =478
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Ontario', Event_City='Toronto', Event_Location='' WHERE Event_Code =479
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Ontario', Event_City='Toronto', Event_Location='' WHERE Event_Code =480
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Blackwater Falls', Event_Location='' WHERE Event_Code =481
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =482
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Tennessee', Event_City='Great Smoky Mountain National Park', Event_Location='' WHERE Event_Code =483
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =484
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Hayesville', Event_Location='' WHERE Event_Code =485
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cleveland', Event_Location='' WHERE Event_Code =486
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='North Carolina', Event_City='Charlotte', Event_Location='' WHERE Event_Code =487
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Buckhannon', Event_Location='' WHERE Event_Code =488
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Fairmont', Event_Location='' WHERE Event_Code =489
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Vermont', Event_City='Killington', Event_Location='' WHERE Event_Code =490
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =491
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Monongah', Event_Location='' WHERE Event_Code =492
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='West Virginia', Event_City='Snow Shoe', Event_Location='' WHERE Event_Code =493
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Bangkok', Event_City='Bangkok', Event_Location='' WHERE Event_Code =494
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Yangon', Event_City='Yangon', Event_Location='' WHERE Event_Code =495
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan', Event_City='Hsipaw', Event_Location='' WHERE Event_Code =496
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan', Event_City='Hsipaw', Event_Location='' WHERE Event_Code =497
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan', Event_City='Hsipaw', Event_Location='' WHERE Event_Code =498
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan', Event_City='Hsipaw', Event_Location='' WHERE Event_Code =499
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan', Event_City='Hsipaw', Event_Location='' WHERE Event_Code =500
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Mandalay', Event_City='Mandalay', Event_Location='' WHERE Event_Code =501
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Mandalay', Event_City='Mandalay', Event_Location='' WHERE Event_Code =502
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Mandalay', Event_City='Amarapura', Event_Location='' WHERE Event_Code =503
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Mandalay', Event_City='Inwa', Event_Location='' WHERE Event_Code =504
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Mandalay', Event_City='Sagaing Hill', Event_Location='' WHERE Event_Code =505
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Kalaw', Event_Location='' WHERE Event_Code =506
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Kalaw', Event_Location='' WHERE Event_Code =507
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Kalaw', Event_Location='' WHERE Event_Code =508
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Kalaw', Event_Location='' WHERE Event_Code =509
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Inle Lake', Event_Location='' WHERE Event_Code =510
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Inle Lake', Event_Location='' WHERE Event_Code =511
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Inle Lake', Event_Location='' WHERE Event_Code =512
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Shan State', Event_City='Inle Lake', Event_Location='' WHERE Event_Code =513
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Trat', Event_City='Koh Tao', Event_Location='' WHERE Event_Code =514
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Trat', Event_City='Koh Tao', Event_Location='' WHERE Event_Code =515
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Trat', Event_City='Koh Tao', Event_Location='' WHERE Event_Code =516
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Trat', Event_City='Koh Tao', Event_Location='' WHERE Event_Code =517
UPDATE Event SET Event_Region='Asia', Event_Country='Thailand', Event_State='Trat', Event_City='Koh Phangan', Event_Location='' WHERE Event_Code =518
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =519
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =520
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =521
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =522
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =523
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =524
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =525
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =526
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =527
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =528
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =529
UPDATE Event SET Event_Region='Asia', Event_Country='Myanmar', Event_State='Magwe', Event_City='Bagan', Event_Location='' WHERE Event_Code =530
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =531
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =532
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =533
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =534
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =535
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =536
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =537
UPDATE Event SET Event_Region='Asia', Event_Country='Cambodia', Event_State='North', Event_City='Seim Reap', Event_Location='' WHERE Event_Code =538
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =539
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Chagrin Falls', Event_Location='' WHERE Event_Code =540
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cincinnati', Event_Location='' WHERE Event_Code =541
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cleveland', Event_Location='' WHERE Event_Code =542
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Texas', Event_City='San Antonio', Event_Location='' WHERE Event_Code =543
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Cuyahoga Falls', Event_Location='' WHERE Event_Code =544
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Beachwood', Event_Location='' WHERE Event_Code =545
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='New York', Event_City='Buffalo', Event_Location='' WHERE Event_Code =546
UPDATE Event SET Event_Region='North America', Event_Country='Canada', Event_State='Ontario', Event_City='Tobermory', Event_Location='' WHERE Event_Code =547
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Indiana', Event_City='Fort Wayne', Event_Location='' WHERE Event_Code =548
UPDATE Event SET Event_Region='North America', Event_Country='United States', Event_State='Ohio', Event_City='Mt. Hope', Event_Location='' WHERE Event_Code =549
